-
How to fix: "Msg 8906, Level 16, State 1"
Hello,
I´ve reinstalled from scratch SQL 7 and was executing a loop that consists in calculating balances for each day, from august 1st to november 30th.
when executing august 20th, appeared the following message on the result:
<result of stored procedure >
(3861 row(s) affected)
Location: alloc.cpp:7859
Expression: IAM_bp != NULL
SPID: 7
Process ID: 122
Server: Msg 3624, Level 20, State 1, Procedure p_pmp_carga_unificado_csg, Line 671
DB-Library Process Dead - Connection Broken
Tried to fix executing :
dbcc checkdb
go
dbcc newalloc
go
dbcc checkcatalog
go
dbcc updateusage(0)
go
but it didn´t fixed DB. It has shown the messages below:
<result of dbcc newalloc(database,repair_allow_data_loss) >
Server: Msg 8906, Level 16, State 1
Page (1:87) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 100_PCT_FULL'.
Server: Msg 8906, Level 16, State 1
Page (1:98) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 100_PCT_FULL'.
Server: Msg 8906, Level 16, State 1
Page (1:99) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 100_PCT_FULL'.
Server: Msg 8906, Level 16, State 1
Page (1:101) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 100_PCT_FULL'.
Server: Msg 8906, Level 16, State 1
Page (1:110) in database ID 9 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 100_PCT_FULL'.
Does anyone know how to fix it?
TKS
Masa
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|